Hệ thống quản lý trường học bằng PHP / MySQLi
1 <?php
2 SESSION_START();
3 ?>
4 <!DOCTYPE html>
5 <html>
6
7 <head>
8 <meta charset="utf-8">
9 <meta name="viewport" content="width=device-width, initial-scale=1.0">
10 <title>school management system</title>
11 <link rel="shortcut icon" href="assets/img/title.gif" type="image/x-icon">
12 <link rel="stylesheet" href="assets/css/bootstrap.min.css">
13 <link href="assets/css/loader.css" rel="stylesheet" />
14 <script src="assets/js/canvasjs.min.js"></script>
15 <!--*****jquery -3.2.1.js file supports the use of dropdown***-->
16 <script src="assets/js/jquery-3.2.1.js"></script>
17 </head>
18
19 <body >
20 <!--end of heading section-->
21 <ul class="nav navbar-right top-nav">
22 <div class="dropdown">
23 <button class="btn btn-primary dropdown-toggle" type="button" data-toggle="dropdown" >
24 <?php
25 //Check to see if the user is logged in.if not redirect user to the loging page.
26
27 if(isset($_SESSION['fname']))
28 {
29 echo "Current user: ".$_SESSION['fname']. " ".$_SESSION['lname']. " ";
30 }else{
31 echo "<script type='text/javascript'>
32 alert( 'You must Log in to use the system');
33 </script>";
34 echo "<script>
35 window.location = 'index.php'
36 </script>";
37 }
38 ?>
39 <span class="caret"></span></button>
40 <ul class="dropdown-menu">
41 <li><a href="manage_account.php"><i class="fa fa-users fa-lg"></i> View User</a></li>
42 <li><a href="register_form.php"><i class="fa fa-users fa-lg"></i> Add New User</a></li>
43 <li class="divider"></li>
44 <li><a href="session_logout.php"><i class="fa fa-fw fa-power-off"></i> Log Out</a></li>
45 </ul>
46 </div>
47 </ul>
48 <!--************************************************-->
49 <div style="
50 font-family:Nyala, Arial;
51 text-align: left;
52 background-color: #526F35;
53 padding: 20px;
54 color:white;
55 width: 100%;
56 height: 150px;">
57 <!--This codes to load the image loader-->
58 <div id="loading">
59 <img id="loading-image" src="assets/img/loader.gif" alt="Loading..." />
60 </div>
61 <!--this is the heading section-->
62 <h2>
63 <?php
64 $sql="SELECT * FROM companyinfo";
65 $result=mysqli_query($db,$sql) or die("error getting data");
66 $num_rows=mysqli_num_rows($result);
67 while($row=mysqli_fetch_array($result))
68 {
69 echo '<image style="height:82px; width:82px;" src="data:image;base64,'. $row['clogo'].' "> ';
70 $cname = $row['cname'];
71 $cemail = $row['cemail'];
72 $ccontact = $row['ccontact'];
73 $clocation = $row['clocation'];
74 }?>
75 <?php
76 echo $cname;
77 ?>
78
79 <div style="float:right; font-size:20px;text-align:right;">
80
81 <img src="assets/img/mail2.png">Email: <?php echo $cemail; ?><br>
82 <img src="assets/img/call1.png">Contact:<?php echo $ccontact; ?><br>
83 <img src="assets/img/location.png">Location: <?php echo $clocation; ?>
84
85 </div>
86 </h2>
87 </div>
88 <!--end of heading section-->
89
90 <div>
91 <ul class="nav nav-tabs">
92 <li ><a href="homepage.php" >Administration <img src="assets/img/details.png"></a></li>
93 <li class="active"><a href="students.php" >Students <img src="assets/img/student48.png"></a></li>
94 <li><a href="staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
95 <li><a href="course.php" >Courses <img src="assets/img/course.png"></a></li>
96 <li><a href="departments.php" >Departments <img src="assets/img/department.png"></a></li>
97 <li><a href="markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
98 <li><a href="hostel.php" >Hostel <img src="assets/img/details.png"></a></li>
99 <li><a href="parents.php">Visitors <img src="assets/img/details.png"></a></li>
100 <!--<li><a href="tab-8" role="tab" data-toggle="tab">Hostel <img src="assets/img/details.png"></a></li>
101 <li><a href="tab-7" role="tab" data-toggle="tab">Parents <img src="assets/img/details.png"></a></li>-->
102
103 </ul>
104 <div class="tab-content">
105 <div class="tab-pane active" role="tabpanel" id="tab-1">
106
107 <p>
108 <div class="table-responsive" >
109 <!--****************************************************************************-->
110 <div class="container" style="width:100%">
111
112 <ul class="nav nav-tabs">
113 <li ><a href="students.php">New Student <img src="assets/img/new.png"> </a></li>
114 <li ><a href="updatestudent.php">Update Existing Record <img src="assets/img/update2.png"> </a></li>
115 <li><a href="deletestudentrecord.php">Delete Record<img src="assets/img/delete2.png"></a></li>
116 <li class="active"><a href="viewstudentrecord.php">View List<img src="assets/img/view2.png"></a></li>
117 <li><a href="importstudentlist.php">Import Data (CSV) <img src="assets/img/import.png"></a></li>
118 <li><a href="exportstudentlist.php">EXPORT Data (CSV) <img src="assets/img/export.png"></a></li>
119 <li><a href="searchstudent.php">Search <img src="assets/img/search.png"></a></li>
120 <li><a href="billingstudent.php">Billing </a></li>
121 <li><a href="studentcreditnotes.php">Credit Notes </a></li>
122 </ul>
123 <br>
124
125 </div>
126
127 <!--*************************************************************************************************************************-->
128
129
130 <h4>View Students</h4>
131 <form method="POST" action="viewstudentrecord.php">
132 <input type="hidden" name="submitted" value="true"/>
133 <label>Search Caterory
134 <select name="category">
135 <option value="dateofadmission">dateofadmission</option>
136 <option value="admno">admno</option>
137 <option value="SirName">SirName</option>
138 <option value="Firstname">Firstname</option>
139 <option value="lastname">lastname</option>
140 <option value="idno">idno</option>
141 <option value="dateofbirth">dateofbirth</option>
142 <option value="gender">gender</option>
143 <option value="mobile">mobile</option>
144 <option value="courseid">courseid</option>
145
146 </SELECT>
147 </label>
148 <label>Search Criteria<input type="text" name="criteria" align="center"></label>
149
150 <input type="submit" />
151 </form>
152
153 <?php
154 include("connect.php");
155 $sql="SELECT * FROM studentstable";
156 $result=mysqli_query($db,$sql) or die("error getting data");
157 $num_rows=mysqli_num_rows($result);
158 echo "$num_rows results found </font>";
159 echo '<table class="table table-striped">';
160 echo '<tr><th >dateofadmission</th><th>admno</th><th>SirName</th><th>Firstname</th><th>lastname</th><th>idno</th><th>dateofbirth</th><th>gender</th><th>mobile</th><th>courseid</tr>';
161 while($row=mysqli_fetch_array($result))
162 {
163 echo '<tr align="left" bgcolor="#EBEBD3" style="font-size:12px"><td>';
164 echo $row['dateofadmission'];
165 echo '</td><td>';
166 echo $row['admno'];
167 echo '</td><td>';
168 echo $row['sirname'];
169 echo '</td><td>';
170 echo $row['firstname'];
171 echo "</td><td>";
172 echo $row['lastname'];
173 echo "</td><td>";
174 echo $row['idno'];
175 echo "</td><td>";
176 echo $row['dateofbirth'];
177 echo "</td><td>";
178 echo $row['gender'];
179 echo "</td><td>";
180 echo $row['mobile'];
181 echo "</td><td>";
182 echo '<a href=course.php>'.$row['courseid'].'</a>';
183 echo "</td><td>";
184 //echo '<image height="50" width="50" src="data:image;base64,'. $row['image'].' "> ';
185 echo "</td></tr>";
186 }
187 /* echo '<tr><td colspan="9" align="right"> <input type="button" value="Print" ></td></tr>';*/
188 echo "</table>";
189
190 ?>
191 <!--****************************************************************************-->
192 </div>
193 </p>
194
195 </div>
196
197 </div>
198 </div>
199
200 <div class="col-md-12" style="background-color:#526F35;bottom:0px; position:fixed;">
201 <p class="text-center text-danger" style="color:white;" >@J. Muthama Tel: +254729734768</p>
202 </div>
203 <script src="assets/js/jquery.min.js"></script>
204 <script src="assets/bootstrap/js/bootstrap.min.js"></script>
205 <script src="assets/js/affix.js"></script>
206 <script src="assets/js/alert.js"></script>
207 <script src="assets/js/alert1.js"></script>
208 <script src="assets/js/bootstrap.js"></script>
209 <script src="assets/js/bootstrap.min.js"></script>
210 <script src="assets/js/bootstrap-datepicker.js"></script>
211 <script src="assets/js/bootstrap-wysihtml5.js"></script>
212 <script src="assets/js/button.js"></script>
213 <script src="assets/js/carousel.js"></script>
214 <script src="assets/js/chosen.jquery.min.js"></script>
215 <script src="assets/js/ckeditor.js"></script>
216 <script src="assets/js/collapse.js"></script>
217 <script src="assets/js/color.js"></script>
218 <script src="assets/js/dropdown.js"></script>
219 <script src="assets/js/DT_bootstrap.js"></script>
220 <script src="assets/js/dynamic.js"></script>
221 <script src="assets/js/ie-emulation-modes-warning.js"></script>
222 <script src="assets/js/jquery.dataTables.js"></script>
223 <script src="assets/js/jquery.dataTables.min.js"></script>
224 <script src="assets/js/jquery.dialog.js"></script>
225 <script src="assets/js/jquery.hoverdir.js"></script>
226 <script src="assets/js/jquery.jgrowl.js"></script>
227 <script src="assets/js/jquery.knob.js"></script>
228 <script src="assets/js/jquery.uniform.min.js"></script>
229 <script src="assets/js/jquery-1.8.3.min.js"></script>
230 <script src="assets/js/jquery-1.9.1.js"></script>
231 <script src="assets/js/jquery-1.9.1.min.js"></script>
232 <script src="assets/js/jquery-1.10.2.js"></script>
233 <script src="assets/js/jquery-1.11.0.js"></script>
234 <script src="assets/js/jquery-ui-1.9.2.custom.min.js"></script>
235 <script src="assets/js/jquery-ui-1.10.3.js"></script>
236 <script src="assets/js/modal.js"></script>
237 <script src="assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
238 <script src="assets/js/myjquery.js"></script>
239 <script src="assets/js/myjquery1.js"></script>
240 <script src="assets/js/npm.js"></script>
241 <script src="assets/js/popover.js"></script>
242 <script src="assets/js/profile.js"></script>
243 <script src="assets/js/raphael-min.js"></script>
244 <script src="assets/js/sb-admin-2.js"></script>
245 <script src="assets/js/scripts.js"></script>
246 <script src="assets/js/scrollspy.js"></script>
247 <script src="assets/js/tab.js"></script>
248 <script src="assets/js/tooltip.js"></script>
249 <script src="assets/js/transition.js"></script>
250 <script src="assets/js/wysihtml5-0.3.0.js"></script>
251 <script language="javascript" type="text/javascript">
252 $(window).load(function()
253 {
254 $('#loading').hide();
255 });
256 </script>
257 </body>
258
259 </html>